<?php

$installer = $this;

$installer->startSetup();

$installer->run("

-- DROP TABLE IF EXISTS {$this->getTable('custom_warehouse_address')};
CREATE TABLE {$this->getTable('custom_warehouse_address')} (
  `entity_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `vendor_id` VARCHAR(11) NOT NULL DEFAULT '',
  `sender_company` VARCHAR(50) NOT NULL DEFAULT '',
  `sender_name` VARCHAR(50) NOT NULL DEFAULT '',
  `sender_email` VARCHAR(50) NOT NULL DEFAULT '',
  `sender_zip_code` VARCHAR(20) NOT NULL DEFAULT '',
  `sender_mobile` VARCHAR(20) NOT NULL DEFAULT '',
  `sender_phone` VARCHAR(30) NOT NULL DEFAULT '',
  `sender_country` VARCHAR(30) NOT NULL DEFAULT '',
  `sender_province` VARCHAR(30) NOT NULL DEFAULT '',
  `sender_city` VARCHAR(30) NOT NULL DEFAULT '',
  `sender_address` VARCHAR(200) NOT NULL DEFAULT '',
  `is_default` SMALLINT(2) NOT NULL DEFAULT '0',
  `created_time` DATETIME DEFAULT CURRENT_TIMESTAMP,
  `update_time` DATETIME NULL,
  PRIMARY KEY (`entity_id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;




");

$installer->endSetup(); 